FaFISAPVarianceDetails

Logical Entity Name | FaFISAPVarianceDetails
Default Table Name | FaFISAPVarianceDetails
Physical Only | NO
Owner | dbo
Definition |
Note |

FaFISAPVarianceDetails Columns

ColumnName | Domain | Datatype | NULL | Definition
FaFISAPVarianceDetailsID |  | int | NO |
BatchIdentifier |  | uniqueidentifier | NO |
LastName |  | varchar(128) | YES |
FirstName |  | varchar(128) | YES |
MI |  | varchar(1) | YES |
SSN |  | varchar(30) | YES |
Model |  | char(1) | YES |
SyStudentID |  | int | YES |
SyCampusID |  | int | YES |
AwardYear |  | varchar(7) | YES |
CampusCode |  | char(8) | YES |
CampusDescription |  | varchar(50) | YES |
FISAPIncome |  | int | YES |
DetailPerkins |  | money | YES |
DetailSEOG |  | money | YES |
DetailWorkst |  | money | YES |
CashPerkins |  | money | YES |
CashSEOG |  | money | YES |
CashWorkst |  | money | YES |
VarPerkins |  | money | YES |
VarSEOG |  | money | YES |
VarWorkst |  | money | YES |
DateAdded |  | datetime | YES |
DateLstMod |  | datetime | YES |
UserID |  | int | NO |
ts |  | timestamp | NO |

FaFISAPVarianceDetails Primary and Unique Keys

Key Name | Key Type | Keys
FaFISAPVarianceDetails_BatchIdentifier_FaFISAPVarianceDetailsID_U_N_IDX | Index | BatchIdentifier, FaFISAPVarianceDetailsID
PK_FaFISAPVarianceDetails_FaFISAPVarianceDetailsID | PrimaryKey | FaFISAPVarianceDetailsID

FaFISAPVarianceDetails Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaFISAPVarianceDetails Check Constraints

Check Constraint Name | CheckConstraint

FaFISAPVarianceDetails Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaFISAPVarianceDetails Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaFISAPVarianceDetails | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaFISAPVarianceDetails | NO |  |  |

FaFISAPVarianceDetails Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaFISAPVarianceDetails Data Movement Rules

Name | Type | Rule Text/Value